LOAD DATA
TRUNCATE 
INTO TABLE gex_bde_tppm_tb
TRAILING NULLCOLS 
(line_no                SEQUENCE(MAX)
,date_prod		POSITION(1:11)		"TO_DATE(:date_prod,'YYYY/MM/DD')"                      
,cd_portefeuille	POSITION(12:27)		CHAR 
,cd_division		POSITION(28:43) 	CHAR
,cd_direction		POSITION(44:59) 	CHAR    
,cd_activite		POSITION(60:75)		CHAR
,cd_mode_gestion 	POSITION(76:91) 	CHAR
,cd_cl_actif		POSITION(92:107)	CHAR
,cd_titre		POSITION(108:123)	CHAR
,provenance 		POSITION(124:134)	CHAR
,mnt_pp			POSITION(135:155)	"TO_NUMBER(:mnt_pp,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,id_titre		POSITION(156:167)	CHAR		       	   
)                                                                                                      
